{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Main","Ref. Info.","Calculations"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":32,"n_cols":21,"rows_kept":32,"cut":false,"hidden":false,"merged":[[10,11,10,13],[16,8,19,9],[18,1,18,2],[16,1,16,2],[15,19,15,20],[15,12,15,13],[17,1,17,2],[15,1,15,2],[15,8,15,9],[9,1,9,2],[13,4,14,4],[11,5,11,6],[11,0,11,3],[11,7,11,10],[31,16,31,17],[30,16,30,17],[29,16,29,17],[12,5,12,6],[17,12,17,13],[4,1,4,6],[4,12,4,17],[14,5,14,6],[7,1,7,2],[7,8,7,9],[7,16,7,17],[7,12,7,13],[8,5,8,6],[8,16,8,17],[8,8,8,9],[7,5,7,6],[9,5,9,6],[9,16,9,17],[9,8,9,9],[13,5,13,6],[9,11,9,13]]}
["API 2000",null,null,"7th Edition, Sect. 3.3.2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Richards Industrials"]
["Normal Tank Venting Requirements"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                  Version 1.0c  4/30/25"]
[]
[null,"IN-BREATHING for Blanketing (Padding)",null,null,null,null,null,null,null,null,null,null,"OUT-BREATHING for Vapor Recovery (Depadding)"]
[null,"Pressure Regulator PRV (e.g., 608, etc.)",null,null,null,null,null,null,null,null,null,null,"Back Pressure (Sustaining) Regulator BPRV (e.g., 508, etc.)"]
[]
[null,"Latitude",null,null,null,"Avg. Storage Temp.",null,null,"Enter Tank Vol.",null,null,null,"Liquid Type",null,null,null,"Y-Factor"]
[null,null,null,null,null,80,null,null,2262,null,null,null,null,null,null,null,{"$f":"Calculations!E11","v":0.25}]
[null,"See World Map",null,null,null,"Degrees F",null,null,"Cubic Feet",null,null,"   Non-Vol.:  V.P. ≤ 0.73 psi (5.0 kPa)",null,null,null,null,"Reference"]
[null,null,null,null,null,null,null,null,null,null,null,"     Volatile.:  V.P. > 0.73 psi (5.0 kPa)"]
["Vapor Pressure Range",null,null,null,null,"C-Factor",null,"    Insulation Thk., in. (mm)"]
[null,null,null,null,null,{"$f":"Calculations!B11","v":4}]
[null,{"$f":"CONCATENATE(\"Hexane V.P. at Temp.  \",ROUND(Calculations!W29,3),\" \",Calculations!W24)","v":"Hexane V.P. at Temp.  3.148 psia"},null,null,null,"Reference"]
[null,null,null,null,null,null,null,null,"Ri Reduction-Factor"]
[null,"Pump Out",null,null,null,null,null,null,{"$f":"Calculations!R12","v":1},null,null,null,"Pump In"]
[null,25,null,null,null,null,null,null,"For 0.7 Btu/h·ft2·oF\n[4 W/(m2·K)] tank heat transfer coeff., & 0.05 W/(m·k) insul. thermal conductivity.",null,null,null,25,{"$f":"Calculations!K8","v":"GPM"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Units Same as Pump-out"]
[]
[]
[null,"  Instructions: "]
[null,"1)","Fill in all white boxes / drop downs"]
[null,"2)","Calculation automatic when data entered or selected"]
[null,"3)","To print this page, select \"Print\" button"]
[null,"Use this program to determine required In- and Out-Breathing gas flows"]
[null,"Size blanketing regulators using sizing charts or JVCV "]
[null,"For additional information, "]
[]
[]
[null,null,null,null,null,"Blanketing Regulator Flow =",{"$f":"Calculations!B19","v":2946.8477519813346},"SCFH",{"$f":"G30*0.02831685","v":83.445445765692654},"NCMH",null,null,null,null,null,"Vapor Recovery Regulator Flow =",{"$f":"Calculations!B23","v":594.92124216206662},null,"SCFH",{"$f":"Q30*0.02831685","v":16.846295576116916},"NCMH"]
[null,null,null,null,null,"Due to liquid movement (pump-out) =",{"$f":"Calculations!F19","v":200.5},null,{"$f":"G31*0.02831685","v":5.6775284250000002},null,null,null,null,null,null,"Due to liquid movement (pump-in) =",{"$f":"Calculations!F23","v":200.5},null,null,{"$f":"Q31*0.02831685","v":5.6775284250000002}]
[null,null,null,null,null,"Due to thermal in-breathing =",{"$f":"Calculations!J19","v":2746.3477519813346},null,{"$f":"G32*0.02831685","v":77.767917340692662},null,null,null,null,null,null,"Due to thermal out-breathing =",{"$f":"Calculations!J23","v":394.42124216206668},null,null,{"$f":"Q32*0.02831685","v":11.168767151116919}]

{"sheet":"Ref. Info.","index":1,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[7,6,9,6],[29,1,34,5],[3,1,3,5],[6,1,9,1],[8,2,8,5],[7,2,7,3],[7,4,7,5],[6,2,6,5],[14,1,15,5],[17,1,18,5],[27,1,27,6]]}
[]
[]
[]
[null,"C-, Y-, and Ri factors shown for reference only.  Program automatically selects factors, based on used selected latitude, storage temperature, liquid type (volatility), and vapor pressure."]
[]
[null,"C- and Y-Factors"]
[null,"Latitude","C-Factor",null,null,null,"Y-Factor"]
[null,null,"Vapor Pressure Similar to Hexane",null,"Vapor Press. > than Hexane or Unknown"]
[null,null,"Average Storage Temperature"]
[null,null,"< 77 F","> 77 F","< 77 F","> 77 F"]
[null,"Below 42 Degrees",4,6.5,6.5,6.5,0.32]
[null,"Between 42 and 58 Degrees",3,5,5,5,0.25]
[null,"Above 58 Degrees",2.5,4,4,4,0.2]
[]
[null,"The C-factor considers the effect of vapor pressure, average storage temperature, and location (latitude) on pump-in (inbreathing or padding) flow for tank blanketing regulators (PRV's)."]
[]
[]
[null,"The Y-factor considers the effect of location (latitude) on pump-out (outbreathing or depadding) flow for tank vapor recovery back pressure (sustaining) regulators (BPRV's). "]
[]
[]
[null,"Insulation Reduction Factor Ri"]
[null,"Based on "]
[null,"     -- Inside heat transfer coefficient of 0.7 Btu/h·ft2·oF (4 W/(m2·K) for typical tank (API2000 7th ed 3.3.2.4)"]
[null,"     -- Insulation thermal conductivity of 0.05 W/(m·k) for Cellular Glass insulation."]
[null,"     -- Fully insulated tank"]
[]
[null,"Hexane Vapor Pressure"]
[null,"Hexane vapor pressure, shown for comparison, calculated between range of -13F and +198F (-29C and +92C), using Antoine equation."]
[]
[null,"DISCLAIMER\nThis program calculates the required in-breathing and out-breathing tank blanketing gas flow based on the input data, according to the method in API 2000 7th edition, Section 3.3.  While this program is presented in good faith and believed to be reasonably accurate, Jordan Valve, a division of Richards Industrials, makes no warranty, either expressed or implied. In no event shall Jordan Valve, a division of Richards Industrials, be liable to anyone for any special, collateral, incidental or consequential damage in connection with these calculations."]

{"sheet":"Calculations","index":2,"n_rows":32,"n_cols":24,"rows_kept":32,"cut":false,"hidden":true,"merged":[[22,19,22,22],[1,18,5,20],[6,0,7,0],[18,5,18,7],[19,5,19,7],[20,5,20,7],[17,9,17,11],[18,9,18,11],[19,9,19,11],[21,9,21,11],[22,9,22,11],[0,3,0,4],[0,1,0,2],[14,1,15,1],[14,2,15,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[4,3,4,4],[5,3,5,4],[6,1,6,2],[6,3,6,4],[3,3,3,4],[7,3,7,4],[7,1,7,2],[2,1,2,2],[23,9,23,11],[22,5,22,7],[17,5,17,7],[1,1,1,2],[20,9,20,10],[1,3,1,4],[2,3,2,4],[17,1,17,3],[21,1,21,2],[21,5,21,7],[23,5,23,7]]}
[null,"Latitude",null,"Vapor Pressure",null,"Storage Temp Units","Temp Input","Tank Vol. Units","Tank Vol. Input","Liquid Type","Pump OUT/IN Units","Pump OUT Rate Input","Pump IN Rate Input",null,null,null,"Insulation Thickness","Ri 7th ed Eqn 11","Insulation Reduction Factor"]
[1,"Below 42°",null,"Similar to Hexane",null,"Fahrenheit",{"$f":"Main!F9","v":80},"Barrels",{"$f":"Main!I9","v":2262},"Volatile","GPM",{"$f":"Main!B17","v":25},{"$f":"Main!M17","v":25},null,1,"None",0,1,"Insulation reduction factor based on heat transfer coefficient h = 4 W/(m2K), thermal conductivity λin = 0.05 W/(mK), and Eqn. (11) in API 2000 7th ed."]
[2,"Between 42 and 58°",null,"Higher than Hexane",null,"Celsius","Temp in Selected Units","Cubic Feet","Vol in Selected Units","Non-Volatile","LPM","Pump-OUT in Units","Pump-IN in Units",null,2,"1 in. (25mm)",1,0.3298153034300792]
[3,"Above 58°",null,"Unknown",null,"-",{"$f":"IF(F7=1,G2*1,(G2*(9/5))+32)","v":80},"Liters",{"$f":"IF(H7=1,I2*5.618,IF(H7=2,I2*1,IF(H7=3,I2*0.0353147,IF(H7=4,I2*35.3147,I2*0.133681))))","v":2262},"-","M^3/HR",{"$f":"IF(K7=1,L2*1,IF(K7=2,L2/3.78541,L2*4.4029))","v":25},{"$f":"IF(K7=1,M2*1,IF(K7=2,M2/3.78541,M2*4.4029))","v":25},null,3,"2 in. (50mm)",2,0.19747235387045817]
[4,"-",null,"-",null,"-","Temp in F","Cubic Meters","Vol in ft3","-","-","Pump-OUT in GPM","Pump-IN in GPM",null,4,"3 in. (75mm)",3,0.14092446448703494]
[5,"-",null,"-",null,"-","-","Gallons","-","-","-","-","-",null,5,"4 in. (100mm)",4,0.10955302366345313]
["Selection:",2,null,1,null,1,"-",2,"-",2,1,"-","-",null,6,"6 in. (150mm)",6,7.5803517283201935E-2]
[null,{"$f":"CHOOSE(B7, B2,B3,B4)","v":"Between 42 and 58°"},null,{"$f":"CHOOSE(D7, D2,D3,D4)","v":"Similar to Hexane"},null,{"$f":"CHOOSE(F7,F2,F3)","v":"Fahrenheit"},"-",{"$f":"CHOOSE(H7,H2,H3,H4,H5,H6)","v":"Cubic Feet"},"-",{"$f":"CHOOSE(J7,J2,J3)","v":"Non-Volatile"},{"$f":"CHOOSE(K7,K2,K3,K4)","v":"GPM"},"-","-",null,7,"8 in. (200mm)",8,5.7950857672693569E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"10 in. (250mm)",10,4.6904315196998121E-2]
[null,"C-Factor",null,null,"Y-Factor",null,"T < or ≥77",null,null,"Volatility Corr.",null,null,null,null,9,"12 in. (300mm)",12,3.9394894421682952E-2]
[null,{"$f":"IF((AND(B7=1,D7=1,G11=1)),B12,IF((AND(B7=1,D7=1,G11=2)),C12,IF((AND(B7=2,D7=1,G11=1)),B13,IF((AND(B7=3,D7=1,G11=1)),B14,IF((AND(B7=1,D7>=2,G11=2)),C12,IF((AND(B7=2,D7>=2,G11=2)),C13,C14))))))","v":4},null,null,{"$f":"IF(B7=1,E12,IF(B7=2,E13,E14))","v":0.25},null,{"$f":"IF(G4<77,1,2)","v":2},null,null,{"$f":"IF(J7=1,16.04,8.02)","v":8.02},null,null,null,null,"Selection:",1,"in. Thk.","Insul. Reduct. Factor"]
[null,4,6.5,"<42F",0.32,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE(P11,P2,P3,P4,P6,P7,P8,P9,P10,)","v":"None"},{"$f":"VLOOKUP($P$11,$O$2:$R$10,3)","v":0},{"$f":"VLOOKUP($P$11,$O$2:$R$10,4)","v":1}]
[null,3,5,"≥42F&≤58F",0.25]
[null,2.5,4,">58F",0.2]
[null,"~Hexane & <77F",">77F &/or >Hexane"]
[]
[]
[null,"Blanketing Flow Required",null,null,"=","Blanketing Flow due to Pump Out",null,null,"+","Blanketing Flow due to Thermal",null,null,null,null,null,"Hexane Vap. Press. at Avg. Storage Temp."]
[null,{"$f":"(L4*8.02)+(3.08*B11*(I4^0.7)*R12)","v":2946.8477519813346},"GPM",null,null,{"$f":"L4*8.02","v":200.5},null,null,null,{"$f":"(3.08*B11*(I4^0.7)*R12)","v":2746.3477519813346},null,null,null,null,null,"Antoine Equation"]
[null,"=(L4*8.02)+(3.08*B11*(I3^0.7))*R12",null,null,null,"=PumpOutGPM*8.02",null,null,null,"=3.08*CFact*(TankVol0.7)*InsulFact",null,null,null,null,null,"log(P) = A-B/(T+C)",null,null,"P in mmHg, T in Celsius"]
[]
[null,"Vapor Recovery Flow",null,null,"=","Blanketing Flow due to Pump In",null,null,"+","Blanketing Flow due to Thermal",null,null,null,null,null,"Antoine Coefficients (Hexane)",null,null,null,"ID = 274","Formulae = C6H14"]
[null,{"$f":"(M4*J11)+(1.51*E11*(I4^0.9)*R12)","v":594.92124216206662},"GPM",null,null,{"$f":"(M4*J11)","v":200.5},null,null,null,{"$f":"(1.51*E11*(I4^0.9)*R12)","v":394.42124216206668},null,null,null,null,null," A"," B"," C ","Temp","Vapor Pressure",null,null,null,"(Temp)"]
[null,"=(M4*J11)+(1.51*E11*(I4^0.9)*R12)",null,null,null,"=(PumpInGPM*8.02*Volatility Corr)",null,null,null,"=1.51*YFact*(Tank0.9)*InsulFact",null,null,null,null,null,6.8702399999999999,1168.72,224.21,"oC","mmHg","psia","kPa",{"$f":"IF(F7=1,U24,V24)","v":"psia"},"oF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tmin ",-25,{"$f":"10^($P$24-$Q$24/($R$24+S25))","v":10.080132566345686},{"$f":"0.01933677*T25","v":0.19491720500493626},{"$f":"0.133332239*T25","v":1.3440066444876861},{"$f":"IF(F7=1,U25,V25)","v":0.19491720500493626},{"$f":"CONVERT(S25, \"C\", \"F\")","v":-13}]
[null,"Verified against examples in article from Tank Storage Magazine 2015, Sizing tank blanketing regulators using the latest API 2000 7th edition guidelines",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tmax",92,{"$f":"10^($P$24-$Q$24/($R$24+S26))","v":1493.534318695702},{"$f":"0.01933677*T26","v":28.88012960772549},{"$f":"0.133332239*T26","v":199.13627473503749},{"$f":"IF(F7=1,U26,V26)","v":28.88012960772549},{"$f":"CONVERT(S26, \"C\", \"F\")","v":197.6}]
[null,"JJH  2/16/22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tselect",{"$f":"IF($F$7=1,CONVERT($G$2,\"F\",\"C\"),$G$2)","v":26.666666666666664},{"$f":"10^($P$24-$Q$24/($R$24+S27))","v":162.81558016616893},{"$f":"0.01933677*T27","v":3.1483274260897702},{"$f":"0.133332239*T27","v":21.708565847639292},{"$f":"IF(F8=1,U27,V27)","v":21.708565847639292},80]
[]
[null,null,"To Main",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vap Press for Selected Units w/in Temp. Range =",null,null,null,null,{"$f":"IF(F7=1,IF(U27<U25,\"<-0.195\",IF(U27>U26,\">28.88\",U27)),IF(U27<U25,\"<-0.195\",IF(U27>U26,\">28.88\",V27)) )","v":3.1483274260897702}]
[null,null,"From Main"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ver. 1.0b -- mmHg to kPa conversion corrected JJH 10/11/24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ver. 1.0c -- Volatile & Non-Vol. informative note corrected JJH 4/30/25"]